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 2000 Forums
 Transact-SQL (2000)
 database is full

Author  Topic 

putane.sanjay
Yak Posting Veteran

77 Posts

Posted - 2006-09-29 : 07:49:46
Hi
what should be done when the sql database is Full & there is no space in the disk.

how to take backup from from one server to the other server
please give suggestions

regards
P.M.SANJAY

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-09-29 : 07:52:25
You can manage most tasks in Enterprise Manager.
Rigth click the database you want to backup and choose "All tasks" and then "Backup database".
Follow the instructions given.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

nosepicker
Constraint Violating Yak Guru

366 Posts

Posted - 2006-09-29 : 20:00:32
Set up a share on a different server, and then when you go through the backup db wizard, at the appropriate window type something like:

\\YourServer\YourShareName\YourDbBackup.bak

Go to Top of Page
   

- Advertisement -