Backup and Restore - Config script

Hi all, how can I move my data from one Sql Server to a
new one I installed recently?, I mean, I want all my
databases and data (I created) that I have in my old
Server be copied in my new one. Is it just as simple as
making a Backup and then Restore my data?. Can I have the
same name for my Sql Server, if my new server is in a
different domain?. And one more question, I want to see
my actual Sql Server configuration, I mean when I
installed I chose some options I don't remember now, for
example: case sensitive, insensitive, dictionary order,
etc. So when I install my new SQL server I can pick the
same options and my new Server will act as my old one.
That's what I have planned!, I hope you can help me.
Thanks in advance
Freddy E.Moving SQL Server Databases
http://www.support.microsoft.com/?id=224071
Moving Databases between Servers
http://www.support.microsoft.com/?id=314546
Using WITH MOVE in a Restore to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
http://www.support.microsoft.com/?id=240872
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Freddy E." <freddye@.discussions.microsoft.com> wrote in message
news:1d61801c45451$379ee1a0$a601280a@.phx.gbl...
> Hi all, how can I move my data from one Sql Server to a
> new one I installed recently?, I mean, I want all my
> databases and data (I created) that I have in my old
> Server be copied in my new one. Is it just as simple as
> making a Backup and then Restore my data?. Can I have the
> same name for my Sql Server, if my new server is in a
> different domain?. And one more question, I want to see
> my actual Sql Server configuration, I mean when I
> installed I chose some options I don't remember now, for
> example: case sensitive, insensitive, dictionary order,
> etc. So when I install my new SQL server I can pick the
> same options and my new Server will act as my old one.
> That's what I have planned!, I hope you can help me.
> Thanks in advance
> Freddy E.