-3
votes
0answers
21 views

SQL server backup started taking too long [on hold]

I have a database backup job which was taking 8 minutes but last couple of days it's started to taking about 45 minutes. There is no change in the server configuration. Enough disk space available. ...
0
votes
1answer
23 views

SQL Server Backup to Azure Tool

I downloaded and tried the Microsoft SQL Server Backup to Azure tool for SQL Server 2008. My goal was to get access to the backup compression functionality built into it. I have it configured to ...
1
vote
1answer
46 views

Backing up a mirrored SQL environment

I have 2 SQL servers in Mirror configuration. I want to backup these servers but backing up the SQL databases in Mirror state causes an error. These two mirrors also have a witness set. I would ...
0
votes
3answers
76 views

How to warehouse data that is not needed from MS SQL server

I have been asked to truncate a large table in MS SQL Server 2008. The data is not needed but might be needed once every two years. It will NEVER have to be changed, only viewed. The question is, ...
0
votes
1answer
79 views

automatic backup [duplicate]

Possible Duplicate: how to get database backup automatically i want to have automatic backup in my program.it means that for example every 30 minutes a table that contains backup schedules ...
1
vote
1answer
28 views

Error in moving Backup file

I have created a backup file by SQL query like this : BackUp [DBName] to disk=N'Backup path'. now i want to move it to another folder.but i recieve this error: Cannot copy 'Backup file ...
1
vote
3answers
171 views

What database backup utility should I use?

Can anyone recommend a database backup utility, free or paid? Ideally it will backup MSSQL & MySQL, but MSSQL only will suffice allow backup of single tables encrypt backups Many thanks
-2
votes
0answers
23 views

DB Backup on Client when Hoster does not answer emails [closed]

I have got a strange situation where my website hoster does not answer support tickets any more. What I am trying to do is to do a full backup of my hosted sql db. I can access the db alright. ...
1
vote
1answer
131 views

Database backup using sql management studio 2008

I want to retrieve a script for a database that will include operations of creating database, creating tables, and insert all data. How can I achieve this using management studio 2008 please. I have ...
1
vote
2answers
342 views

how to choose backup strategy?

I am DBA of a big online retail company. I am responsible for the availability of the company’s database. The size of this database is 28GB, and it handles an average of 120 transactions every minute. ...
3
votes
3answers
2k views

SQL Server Backup retention policy

I need to backup database in full recovery mode with a condition as: 1. Backup database, only when space is available for backup operation and Backup retention policy must be like expect last two days ...
0
votes
2answers
351 views

Running sql server 2000 backup file on sql server 2008

I restored sql server 2000 .bak file to sql server 2008 by --RESTORE FILELISTONLY --FROM DISK = 'D:\DBHarshal\full backup august 6.BAK' --ALTER DATABASE EPICSms --SET SINGLE_USER WITH --ROLLBACK ...