Tuesday, October 1, 2013

[MS SQL Server] Backuping Stored procs of the Database by using scripts

[MS SQL Server] Backuping Stored procs of the Database by using scripts

Backuping Stored procs of the Database by using scripts

Posted: 30 Sep 2013 05:34 AM PDT

hi all,i want to create a script to backup the stored procs of the database plz suggest.

Restoring my StandBy / ReadOnly Db - HELP PLEASE

Posted: 30 Sep 2013 08:46 PM PDT

Hey guys... i really need some help... I'm new as SQL-DBA, Our LogShipping DB is out of sync (since the windows-team patched the server)We have a primary DB running on a server with logshippingA Secondary DB running on an other server which is in standby / readonly mode. (wich copys and restores the .trn logs from primary. this worked fine until the serverteam patched the backup server (and didnt start the sql-server again) Now my problem... how can i restore the standby db ? I made a fullbackup from the primary today (log shipping is not working for 4 days)--- my plan was to resotre the standby db with the fullback from the primary and after this (the trn from today are still here) it should resync itself... But i'm not able (using SQL Server Manager) to use the "Tasks/Restore/Database" (greyd out) to restore my fullback.now i read something about a command:Restore Database (dbname) from disk='C:\Temp\Fullbackup.bak" with standby = 'xxxxx.ldf'What is this .ldf path for ? i found a .ldf from the Database (secondary) on the path: F:\Microsoft SQL Server\MSSQL\Data\"ourDB-Name".ldf ... Is it ok when i restore my BackupDB (in standby mode) with the following command ? Restore Database OURDBNAME from disk='C:\Temp\Fullbackup.bak" with standby = 'F:\Microsoft SQL Server\MSSQL\Data\"ourDB-Name".ldf' ... i dont wanna break our secondary db :( --> or do i have to create a new .ldf file ? Thanks a lot for your help

SQL Server Service pack upgrade

Posted: 30 Sep 2013 07:27 AM PDT

Hello,I'm trying to upgrade the service packs of all SQL Server (2008,2008 R2 )instances in our environment.I would like to upgrade it through a batch file instead of the GUI. In our environment we use cmd or batch file for sql installation but i'm not sure how to create a batch file for service pack upgrades.Did anyone got a chance to work on this ? Please let me know your suggesstions or thoughts.Fyi, i have the service pack .exe file , i'm looking for a template batch file ...once i'm ready for the upgrade i just want to update the instance name in the batch file.Please let me know if you need more informationThanks in advance
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog