| Author |
 Topic  |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
 Posted - 27 January 2004 : 12:45:47
|
| I'm totally clueless when it comes to sql server. what do I need to do to backup a sql database to another server? I saw there is a feature in sql server to do backups, but can I just copy the necessary files to the other server? I'm trying to write a script that will copy over other files as well, so I wanted to include the database in the same script. |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 27 January 2004 : 13:55:15
|
| yes, you can just transfer the tables etc from one db to another, use the dts wizard, you can then save this as a script which you can run whenever you want |
 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 27 January 2004 : 13:56:13
|
| if you have the same users set up on both servers, do an 'object coby' rather than a 'table transfer' |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 27 January 2004 : 14:12:02
|
what i decided to do was use em to do a backup to another folder on the server and then i'll just copy the backup file to our "backup" server.
when i said script, i was talking a simple batch file or vbs script for copying folders and files. |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 27 January 2004 : 17:20:06
|
| in order to copy the database files you must first unattach it from it's existing server, you can then safely copy them to another server and attach them again, trying to copy them without detaching may mean the two databases get out of sync. |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 27 January 2004 : 18:17:56
|
| i'm just copying the file to a drive for backup ... the place where i'm copying it does not have sql server, so i don't think there is a possibility of attaching ... i don't even know what that is. i did set a backup job in EM, and it seemed to work fine, i.e. creating the backup database in a different folder. this backup database is not attached ... at least i don't think it is. i should be safe then, yes? |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 27 January 2004 : 19:23:36
|
| yes if you are using EM to do the backup. |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
| |
Topic |
|
Topic Locked
</edit>