Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-12-01 : 08:34:25
|
| himanshu writes "Dear SirI am trying to write a code in C# which restores a SQLSERVER 2000 database from an another server having the same SQLSERVER 2000 databses.Please help me.i am using SQL SERVER 2000 SP2 and Windows 2000 server SP4.with regards Himanshu" |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-12-04 : 00:17:09
|
| what have you done so far? take note the user should either be syadmin, dbcreator or dbo of the database (not member of the db_owner role)--------------------keeping it simple... |
 |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2006-12-04 : 05:20:00
|
| I have actually got a DTS job that do that, but then writing a .net app for it so that it works for all. Haven't got it going yet, will need to set aside more time for that :) |
|
|
|
|
|
|
Automated SQL SERVER Restoration from another server