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!
JonJon,
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.me@.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
"Jerry Spivey" <jspivey@.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.me@.adconn.com> wrote in message
> news:biEWe.23145$uD6.12122@.tornado.ohiordc.rr.com...
>|||Some helpful links, I hope...
http://tinyurl.com/azar5
http://tinyurl.com/a6flz
"Jon Glazer" <jglazer.delete.me@.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/defaul...kb;en-us;314546
http://support.microsoft.com/defaul...kb;en-us;224071
"Jerry Spivey" <jspivey@.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.me@.adconn.com> wrote in message
> news:biEWe.23145$uD6.12122@.tornado.ohiordc.rr.com...
>