Viewing 15 posts - 46 through 60 (of 341 total)
What's the error that's raised when you attempt to restore the database?
March 7, 2011 at 6:30 pm
Ray Mond (3/6/2011)
Actually, I meant to write that doing option 2 was fine, and was actually referring to option 2 all the while.
And I take that back, if your objective...
March 6, 2011 at 9:46 am
Actually, I meant to write that doing option 2 was fine, and was actually referring to option 2 all the while.
March 6, 2011 at 8:42 am
I don't have any links to documents that specifically address what you are looking for. To be honest, I've never really thought about it, but I guess I trust...
March 6, 2011 at 7:37 am
Is sql server terminating equivalent to SQL Shutdown with Nowait option?
No, that wouldn't be good for startup recovery. If you run this:
DBCC TRACEON(3502, -1)
SQL Server will then log checkpoints...
March 6, 2011 at 4:54 am
... then windows may kill the SQL process before the checkpoint completes.
Not windows, but the user, as per this page here.
March 6, 2011 at 3:12 am
1. stopping the ms sql server services and restarting the windows machine.
2. Restarting the windows machine without stopping the ms sql server .
Option 1 is fine. When you...
March 6, 2011 at 2:21 am
Any useful details in the SQL Server log? One suggestion would be to use Profiler to trace the events at around 03:30.
March 3, 2011 at 9:54 am
When creating a backup from TSQL, and using a rented database on a cloud server, is it possible to specify a local path (local in the sense of my client...
February 28, 2011 at 10:51 pm
That sounds like putting all your eggs in one big (albeit powerful) basket. Assuming that you're still running nightly full backups and making copies of it off-site, you'll lose...
February 28, 2011 at 10:01 pm
And the TSQL syntax is to add REPLACE to the WITH clause of the backup.
REPLACE is for restores. It's INIT or FORMAT for backups, depending on your previous backup...
February 28, 2011 at 7:28 pm
Perhaps the drive got damaged during transit? Could try generating and comparing MD5 checksums for the original backup file at your client's place, and the file on the USB...
February 24, 2011 at 6:08 pm
Could try measuring the read throughput and write throughput individually, as described here.
February 24, 2011 at 2:44 am
I compre the lsn using restore header. The first lsn of the transaction log backup is in the range of the last filegroup backup and the last lsn of the...
February 23, 2011 at 11:03 pm
Viewing 15 posts - 46 through 60 (of 341 total)