Viewing 15 posts - 17,131 through 17,145 (of 26,489 total)
Actually used it to capture data changes while developing a data modification process when I needed to do destructive testing in a test environment and didn't want to have restore...
January 29, 2010 at 9:58 pm
Table variables are also not affected by transactions. They are good for capturing data inside transactions regardless if the transaction is committed or rolled back.
January 29, 2010 at 9:39 pm
WayneS (1/29/2010)
Lynn Pettis (1/29/2010)
January 29, 2010 at 4:57 pm
Or add a ShopID to the appropriate tables so you know which records belong to which shop. Would require some changes to the indexing probably as well.
January 29, 2010 at 3:50 pm
mw112009 (1/29/2010)
You were right!
That was a transaction log.
We did find the actual backup file it is 78GB large and also there was a second file
that was 12GB...
January 29, 2010 at 3:15 pm
Doesn't tell me a thing.
run the following and post the results:
restore headeronly N'D:\NGProd_backup_201001280600.trn'
restore filelistonly N'D:\NGProd_backup_201001280600.trn'
January 29, 2010 at 2:41 pm
The .trn file is a transaction log backup file, you need to restore the most current FULL backup first. If you also need to restore differential and/or transaction log...
January 29, 2010 at 2:27 pm
Gift Peddie (1/29/2010)
Ritesh Medhe (1/29/2010)
January 29, 2010 at 2:24 pm
Ryan (1/29/2010)
January 29, 2010 at 2:10 pm
Here is a restore command. You will have to make appropriate changes to match your actual environment.
restore database NGProd
from disk = N'D:\Backups\NGProd.bak' -- assumes the file is local
with file...
January 29, 2010 at 2:05 pm
You can restore your database using the most current full backup file and all transaction log backups taken since that full backup to recover your database.
January 29, 2010 at 1:58 pm
Just a guess, but maybe different CU's? My SQL Server 2008 installs are all at 2531, SP 1 with no additional CU's applied.
January 29, 2010 at 12:01 pm
I'm going to go with the standard consultant answer, it depends. At this point, just cut it down to the actual CREATE TABLE statements.
January 29, 2010 at 11:54 am
Viewing 15 posts - 17,131 through 17,145 (of 26,489 total)