December 19, 2016 at 8:11 am
May i know correct and easy way of backup and restore SQL stored procedures?
December 19, 2016 at 8:13 am
Just the stored procedures without the database? Put them in source control, either manually via scripting or via a tool that interfaces directly.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 19, 2016 at 8:18 am
Very much appreciate if If you can provide clear guidance...
anyway How can i backup System Stored procedures also...?
December 19, 2016 at 8:21 am
You don't need to, they can't be changed and you wouldn't be able to 'restore' them.
What are you trying to do here?
Procedures (and views, functions, etc) in source control is a good practice, but it's not really a backup. Backups are what you do of the entire DB.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 20, 2016 at 5:10 am
I want to backup all settings, Data of existing SQL server and restore them another new server.
like a migration...
December 20, 2016 at 5:22 am
Then you back up the user databases and restore them on the other server.
Don't backup and restore the system databases though, script out logins, jobs, server-level permissions, linked servers and run the scripts on the other server.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 20, 2016 at 9:15 am
Thank you for reply.
Can you please provide simple guidance with screen shots....?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply