Viewing 15 posts - 256 through 270 (of 341 total)
Check that the SQL Server service log-on account is a domain user and not the Local System account.
November 9, 2004 at 6:26 pm
Markus, the point I raised on CPU usage was in comparing between native backups and 3rd party SQL Server backup tools. The native backup imposes almost no extra load on...
November 5, 2004 at 11:51 pm
See here for a discussion on compression using standard compression tools (WinZip, WinRar etc) vs online backup/restore compression/decompression tools like MiniSQLBackup.
If you are comparing between the two, then online...
November 4, 2004 at 11:34 pm
In SQL Server Books Online, look for point-in-time in the index.
November 3, 2004 at 8:50 am
>> I realise that people are probably sick of hearing this type of thing by now ...
Not me. Thanks for the reminder.
October 28, 2004 at 9:06 am
Well, for sure the backup will contain the new rows if the trxs have been committed by the time the backup ends.
According to Inside SQL2K by Kalen Dalaney, a...
October 28, 2004 at 9:02 am
A backup contains everything you'll find in the database. Note that full-text catalogs are not stored in the database, so they are never backed up using the BACKUP command.
October 27, 2004 at 8:31 pm
You can't use the WITH MOVE option when restoring differential backups. Also, you might try running the RESTORE HEADERONLY for both backups, and check if the CheckPointLSN for the full...
October 27, 2004 at 8:26 pm
Restore the full database backup using the NORECOVERY or STANDBY options if you want to further apply differential or log restores e.g.
RESTORE DATABASE leon FROM .... WITH NORECOVERY
October 26, 2004 at 10:54 pm
The problem the OPs encountered is the failure to attach databases which were not originally detached. I wouldn't know the internals of the differences between a shutdown and a detach.
From...
October 19, 2004 at 12:54 am
RESTORE LOG MyDatabase FROM DISK = 'Mytranslog.trn' WITH NORECOVERY
October 16, 2004 at 10:07 am
If you take a look at the problem that Jasper Smith solved in the post I mentioned, you would see that the user failed to even attach using sp_attach_single_file_db. Usually,...
October 14, 2004 at 7:45 pm
Lukas, that was a very strange way to prove your point, as you could just as easily have ran sp_attach_db 'pubs', 'C:\Program Files\Microsoft SQL Server\MSSQL\DATA\pubs1.mdf', 'C:\Program Files\Microsoft SQL Server\MSSQL\DATA\pubs1_log.ldf'
Great for...
October 14, 2004 at 10:43 am
PowerDVD301_2_Data.MDF is just the name of the data file that needs to be 'attached' in the example. Replace it with the name of your mdf file.
October 13, 2004 at 8:37 pm
Viewing 15 posts - 256 through 270 (of 341 total)