Viewing 15 posts - 46 through 60 (of 342 total)
What's the error that's raised when you attempt to restore the database?
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
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...
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
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.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
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...
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
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...
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
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.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
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...
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
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.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
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...
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
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...
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
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...
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
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...
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
February 24, 2011 at 6:08 pm
Could try measuring the read throughput and write throughput individually, as described here.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
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...
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
February 23, 2011 at 11:03 pm
Suggested reading: http://www.sqlbackuprestore.com.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
February 22, 2011 at 7:32 pm
Viewing 15 posts - 46 through 60 (of 342 total)