Tagged Questions
10
votes
3answers
360 views
How often to backup the master database?
The suggestion in BOL is fairly vague:
Back up master as often as necessary to protect the data sufficiently
for your business needs. We recommend a regular backup schedule, which
you can ...
9
votes
2answers
314 views
A Non-DBA Asks: How to Painlessly Copy/Move a SQL Server instance to another Server via Backup/Restore?
We've just got a new server so I need to copy the existing SQL Server 2008 instance over from the old db box.
I normally do this by copying .mdf and log files over and attaching them but I'm not able ...
7
votes
6answers
263 views
Scheduled backup task doesn't always backup all databases despite always saying job successful
I have a job in SQL 2008 that runs a stored proc to backup all databases. This runs daily via sql server agent job.
It quits with success every day but some days it quits with success only after ...
7
votes
6answers
255 views
Backing up SQL DB more frequently
I currently have a scheduled task that fires off each night at 2 AM that calls SQLCMD.exe and passes it a .sql script to run for the backup (shown below). We're a pretty small company with growing ...
7
votes
2answers
508 views
Should I stop transaction log backups during a full backup?
I have two SQL Agent jobs which are scheduled to run at different intervals. The first job runs a full backup once a day. The second job runs transaction log backups every fifteen minutes.
As the ...
6
votes
1answer
81 views
When you back up a database and scripts are running at the same time, at what point in time does the backup reflect?
If I run a SQL Server database backup via Management Studio and there are scripts running at the same time, does the backup reflect the point in time when the backup was started or when it ended? My ...
6
votes
1answer
760 views
How can I recover data from the LDF file?
We are using SQL 2005 Express Edition. We want to read the data from the LDF file in order to restore some deleted records.
We tried using a trial version of ApexSQL which helped us a lot. Instead of ...
6
votes
3answers
498 views
Is it possible to restore sql-server bak and shrink the log at the same time?
We have a bak file from a client that we have transferred to our developer offices for problem investigation. The backup is currently 25GB and the restored database is about the same size however it ...
6
votes
3answers
609 views
Why is a .bak so much smaller than the database it's a backup of?
I just took a backup of a SQL Server database. The MDF and LDF files together total around 29 GB, but the .bak file was only 23 GB, about 20% smaller.
My first guess when one version of a set of ...
6
votes
6answers
1k views
Pros and Cons of SQL Server back up strategies and their appropriate usage scenarios
From what I can tell, there are three possible ways of backing up your SQL Server database
Full backup
Differential backup
Log Shipping
What are the pros and cons of each strategy and in what ...
5
votes
2answers
72 views
Performing data update operations while backing up a large SQL Server database
I have a large (in the tens of millions of records) database that I am going to perform a full database backup on.
However, the database is large enough that transactions can start before and during, ...
5
votes
1answer
380 views
How to back up a small database in SQL Server 2008 R2 Express Edition
I will shortly be migrating a database from SQL Server 2000 (part of SBS 2003) to SQL Server 2008 R2 Express Edition
The database is small, and there are only a few hundred short transactions per day ...
4
votes
2answers
114 views
Do I really need to keep .LDF files?
Each month we make an end of month snapshot of our production databse. These month end snapshots are strictly for reporting purposes, there are no inserts, updates or deletes ever done on them. Each ...
4
votes
3answers
120 views
RSync Database File Deltas in SQL Server 2008
Alright, I feel like this is a terrible idea, but I need some help understanding why this is bad:
I'm still working on implementing a disaster recovery/business continuity solution for our ...
4
votes
1answer
58 views
Copy a SQL Server 2000 database to another box without interrupting the backup chain
I have a small-but-important MS SQL Server 2000 database that I'd like to copy to a development box. I understand that the usual way to do this is to make a copy of a full backup file, and restore ...
