March 26, 2009 at 1:44 am
hi,
please help me if there is any option in sql server to take backup all the data and schema of a database excluding transactional log data.
March 26, 2009 at 2:12 am
dharaneeswar_reddy (3/26/2009)
hi,please help me if there is any option in sql server to take backup all the data and schema of a database excluding transactional log data.
Why do you need this? Simple you can shrink Log file then take backup or simple take snapshots!
:w00t:
March 26, 2009 at 2:48 am
I dont have offical permission to shrink the log file..............
so how can i do that in a different way
March 26, 2009 at 5:58 am
dharaneeswar_reddy (3/26/2009)
hi,please help me if there is any option in sql server to take backup all the data and schema of a database excluding transactional log data.
What does it mean by transactional log data? Could you please correct me?
As advised database snapshot should be your friend.
March 26, 2009 at 6:09 am
Let me see if I understand – You can restore a database on the server (and over write an existing database if it exists), but you can’t shrink the log if it is too big? Just out of curiosity can you explain this situation?
As for your question, I’m not aware of an option that lets you restore the data without the log file. By the way can you shrink the log file on the source server before taking the backup?
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 26, 2009 at 8:46 am
dharaneeswar_reddy (3/26/2009)
hi,please help me if there is any option in sql server to take backup all the data and schema of a database excluding transactional log data.
I thought that's what a BACKUP does, take copy of everything, all transactions until the end of backup time
essentially a snapshot at point in time with no more log afterwards
Unless you mean you want to restore without restoring the .LDF file?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply