litespeed bkup n restore...refresh database prod to dev

  • I need documentation on this if any one have the documentation or any links on this.... plsss ..

    thankyou advance...:-)

  • http://weblogs.sqlteam.com/tarad/archive/2009/02/25/How-to-refresh-a-SQL-Server-database-automatically.aspx

    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/

  • 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" 😉

  • If I remember correctly, LiteSpeed can generate those scripts for you.

  • 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.

  • 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.

  • 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