Posted by Erland Sommarskog on 06/07/05 02:01

debian mojo (debian_mojo@yahoo.com) writes:
> As a result, the remote database has become full of databases many of
> which are not needed at the moment.
>
> I plan to remove all unwanted databases on the remote server only
> after taking backups. But there's very little space on the remote server
> and as a result i wont be able to use BACKUP commands to create backup
> copies.
>
> I also wont be able to import these databases from the remote server
> to the local server.
>
> I am planning to copy the .mdf and .ldf files from remote server to
> local server. Will that be OK?

Yes. First detach them from the remote server before you copy.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]