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
 General SQL Server Forums
 New to SQL Server Programming
 Backup

Author  Topic 

Gusain08
Starting Member

1 Post

Posted - 2008-11-04 : 02:15:17
Dear,

I am new to SQL. Right now the problem is that i have a machine in which SQL Server 2000 is installed, but i don't have the password for windows login. That machine is not in domain, but i have the password for SQL. Can u suggest me how can i take backup of that sql server.

Regards

Gusain

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2008-11-04 : 02:51:20
If the password you have is linked to a sql server login that has sufficient permissions to backup ,
then simply logon and backup. You can do this either through a the Enterprise Manager or issue the t-sql command

Jack Vamvas
--------------------
http://www.ITjobfeed.com
Go to Top of Page
   

- Advertisement -