Backing up and restoring a DB

[intheshit]

We have tried using the standard format for backing up our DB using Enterprise Manager in the MMC without any success. All attempts to restore result in a timeout expiry. Please help as we are on a very tight schedule and my job is on the line here! Anyone who knows the SQL script or has an alternative method for carrying this out let me know ASAP!
Thanks.

 

[AshleyRickards]

What type of device are you retoring from and backing up to?

If it's disk/file :

RESTORE DATABASE [your_database_name]
FROM DISK = N'f:\MSsql7\backup\yourfile.bak'
WITH FILE = 1, NOUNLOAD , STATS = 1, RECOVERY , REPLACE

-----

BACKUP DATABASE [your_database_name] TO DISK =
N'G:\mssql\DB_BACKUPS\your_database_name.BAK'
WITH NOINIT , NOUNLOAD , NAME = N'your_database_name backup',
NOSKIP , STATS = 05, NOFORMAT


EM will often timeout. Use query analyzer as it connects directly to sql. EM uses ODBC.

Good Luck! Ashley L Rickards
SQL DBA

 

[Guest_imported]

Thanks for the advice.
I've decided to run all backups/restore this way from now on as I no longer have the blind faith in the whole mmc environment I did previously.

 

[tlbroadbent]

Question.

When using EM to restore you get a timeout. Does this occur after starting the restore or are you even able to get to the point of selecting the file to restore?

I use regularly EM for restores without encountering timeouts. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[AshleyRickards]

When I used EM for SQL 7 I got timed out but now using EM for SQL 2k I don't. Not sure what the change was. Ashley L Rickards
SQL DBA