Backup of Data on SQL 2000 - SQL Server Forums

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

SQL Server Administration (2000)

Backup of Data on SQL 2000

Author

Topic

alistair4267
Starting Member

10 Posts

Posted - 2008-04-17 : 05:14:42

Hello

I have been given the task of backing up a user DB which is 240Mb in size, now my question is

1) When the Export of the DB has finished what "file format" will it be stored in?

2) when is the best time to do the Backup? (morning / night)

3) do i need to de-mount the DB before i perform the backup? or can i do it on the FLY ?

Kind regards
alistair

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2008-04-17 : 06:05:25

1. Backupfile will be named *.bak and be of unknown format to the OS. The format is however (naturally) of sql server backup-format

2. Usually backups ar run at night, a 240MB db wil probably take a few minutes only so it doesn't matter too much at what time.

3. SQL Server backups are an online operatin so there is no need to do anything to the database...

--
Lumbago

alistair4267
Starting Member

10 Posts

Posted - 2008-04-17 : 08:19:40

Thanks for the Reply.

I have just tried to Backup my DB and i am getting this error message.

Backup Database Permission Denied in Database "Skills2008"
Backup Database is terminating abnormally

now from what i belive the problem is that my Username/login is not part of the MASTER DB which is needs to be accessed. is that correct ?

do i need to create a "new user" and then give them Special Rights ?

Kind regards
alistair

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2008-04-17 : 08:24:22

From BOL:

quote:
BACKUP DATABASE and BACKUP LOG permissions default to members of the sysadmin fixed server role and the db_owner and db_backupoperator fixed database roles

--
Lumbago

matador
Starting Member

3 Posts

Posted - 2008-04-17 : 14:38:53

you username does not have the right to do a backup ...

solution 1> change the user role previleges to the one that can do a backup

solution 2 > crteate a new login\user mane with those previleges and them do a backup

alistair4267
Starting Member

10 Posts

Posted - 2008-04-18 : 05:28:06

Thanks for the reply.

i have been informed that no one knows the "GLOBAL ADMIN" for the SQL server so i can't get my permissions sorted.

is there an option to get the ADMIN PASSWORD reset ?

Regards
Alistair

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2008-04-18 : 06:58:39

Hmmmmmmm...is this one of those "I've-lost-my-password-now-how-can-I-reset-it-without-having-a-password"-question?

Try logging on the server using the local administrator account.

--
Lumbago

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-19 : 17:13:12

Or check sql service account and logon server with it if it's not local system.

alistair4267
Starting Member

10 Posts

Posted - 2008-04-22 : 07:12:33

Thanks for all your help.

I am going to install SQL 2005 FRESH and start again. this shouldn't be a problem.

Kind regards
Alistair

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources