September 7, 2011 at 10:34 pm
I need documentation on this if any one have the documentation or any links on this.... plsss ..
thankyou advance...:-)
September 8, 2011 at 3:45 am
For better, quicker answers on T-SQL questions, click on the following...
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/
September 8, 2011 at 4:30 am
AAKR (9/7/2011)
I need documentation on this if any one have the documentation or any links on this.... plsss ..thankyou advance...:-)
how are your backups currently taken through litespeed, litespeed maintenance plan or scripted jobs?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 8, 2011 at 1:15 pm
If I remember correctly, LiteSpeed can generate those scripts for you.
September 8, 2011 at 3:34 pm
I have this in my notes
EXEC master.dbo.xp_backup_database
@database = 'MyDB'
, @filename = '\\MyServer\g$\backup\daily\MyDB.bkl'
AND
EXEC master.dbo.xp_restore_database
@database = 'MyDB',
@filename = '\\MyServer\g$\backup\daily\MyDB.bkl',
@with = 'move "MyDB_data" to "g:\data\MyDB.mdf"',
@with = 'move "MyDB_log" to "e:\log\MyDB.ldf"'
I hope this helps
Cheers
Leo
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
September 8, 2011 at 3:44 pm
I've also got the attached document. I set it up about 2 years ago, but I can't imagine it's changed much.
Cheers
Leo
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
September 11, 2011 at 7:02 pm
You can use these commands ..
--- Lightspeed Backup TSQL Command
exec master.dbo.xp_backup_database
@database = N'Database_X',
-- @GUID = N'7f771816-757e-40fb-9308-0d1787d50fd9',
@backupname = N'Database_X - Full Database Backup',
@desc = N'Full Backup of Database_X on 7/8/2011 11:21:13 AM',
@compressionlevel = 11,
@filename = N'\\ServerName\G$\Database_X.bak',
@with = N'SKIP',
@with = N'STATS = 10'
GO
exec master.dbo.xp_restore_database @database = N'Database_X' ,
@filename = N'G:\Database_X_201108241250.bak',
@filenumber = 1,
@with = N'REPLACE',
@with = N'STATS = 10',
@with = N'NORECOVERY',
@affinity = 0,
@logging = 0
GO
Thank You,
Best Regards,
SQLBuddy
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply