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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 backup databases

Author  Topic 

priyaram
Yak Posting Veteran

82 Posts

Posted - 2007-03-07 : 16:23:53
is it possible to take the system databases backup to a location of another server.

(i.e ) shall we able to take a backup of the databases from server 1 and putting in server2

I know we can move the databases backup file , but above condition is not possible , but before working on this stuff i wamt to make sure.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-03-07 : 16:26:51
Yes that is possible.

Tara Kizer
Go to Top of Page

priyaram
Yak Posting Veteran

82 Posts

Posted - 2007-03-07 : 16:34:44
i think i got confused.

we are having an master db backup in the server 1 , almost it's size is 5GB. we are thinking that " Is it possible that this is a backup of master.mdf from another server? "

is this scnerio possible??
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-03-07 : 16:38:19
There's no way for us to know that information. But yes someone could have restored a master database from another server onto this server.

Tara Kizer
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2007-03-07 : 19:13:14
To see what was recently restored:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54300#268882

5GB is VERY large for a Master database

Kristen
Go to Top of Page
   

- Advertisement -