|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Backup an entire database ...Can someone give me the command to properly backup an entire database
including all security and what-not so I can move it to a different SQL server? The restore command too would help! Thanks! Jon Jon,
An easier and faster way might be to detach the database copy the files over to the new server and then reattch the database there. The commands to use are sp_detach_db and sp_attach_db. Examples and syntax are provided in the SQL Server Books Online. HTH Jerry PS - Note that the logins for the database user accounts will not come over using either method because the logins are stored in the Master system database. The following article will provide more information. http://support.microsoft.com/?id=314546 Show quote "Jon Glazer" <jglazer.delete***@adconn.com> wrote in message news:biEWe.23145$uD6.12122@tornado.ohiordc.rr.com... > Can someone give me the command to properly backup an entire database > including all security and what-not so I can move it to a different SQL > server? The restore command too would help! > > Thanks! > Jon > Wow thanks for the fast reply Jerry.
I just posted a second question regarding mirroring. Since the databases are so huge I was wondering if that would be an alternative and how would I go about doing that. Jon Show quote "Jerry Spivey" <jspi***@vestas-awt.com> wrote in message news:uH0Ou5uuFHA.2960@tk2msftngp13.phx.gbl... > Jon, > > An easier and faster way might be to detach the database copy the files > over to the new server and then reattch the database there. The commands > to use are sp_detach_db and sp_attach_db. Examples and syntax are > provided in the SQL Server Books Online. > > HTH > > Jerry > > PS - Note that the logins for the database user accounts will not come > over using either method because the logins are stored in the Master > system database. > > The following article will provide more information. > > http://support.microsoft.com/?id=314546 > > "Jon Glazer" <jglazer.delete***@adconn.com> wrote in message > news:biEWe.23145$uD6.12122@tornado.ohiordc.rr.com... >> Can someone give me the command to properly backup an entire database >> including all security and what-not so I can move it to a different SQL >> server? The restore command too would help! >> >> Thanks! >> Jon >> > > The following articles explain how to transfer logins after detach/attach:
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546 http://support.microsoft.com/default.aspx?scid=kb;en-us;224071 Show quote "Jerry Spivey" <jspi***@vestas-awt.com> wrote in message news:uH0Ou5uuFHA.2960@tk2msftngp13.phx.gbl... > Jon, > > An easier and faster way might be to detach the database copy the files > over to the new server and then reattch the database there. The commands > to use are sp_detach_db and sp_attach_db. Examples and syntax are > provided in the SQL Server Books Online. > > HTH > > Jerry > > PS - Note that the logins for the database user accounts will not come > over using either method because the logins are stored in the Master > system database. > > The following article will provide more information. > > http://support.microsoft.com/?id=314546 > > "Jon Glazer" <jglazer.delete***@adconn.com> wrote in message > news:biEWe.23145$uD6.12122@tornado.ohiordc.rr.com... >> Can someone give me the command to properly backup an entire database >> including all security and what-not so I can move it to a different SQL >> server? The restore command too would help! >> >> Thanks! >> Jon >> > > Some helpful links, I hope...
http://tinyurl.com/azar5 http://tinyurl.com/a6flz Show quote "Jon Glazer" <jglazer.delete***@adconn.com> wrote in message news:biEWe.23145$uD6.12122@tornado.ohiordc.rr.com... > Can someone give me the command to properly backup an entire database > including all security and what-not so I can move it to a different SQL > server? The restore command too would help! > > Thanks! > Jon >  
Other interesting topics
|
|||||||||||||||||||||||
