SQL Server - database snapshots -restoring status
Asked By noorhayati shamsuddin
17-Nov-09 10:11 PM
Hi,
I had restored a production database backup to a TRAINING database using symantec.I accidently asked symantec to restore model,msdb and database snaphots to an existing TRAINING database. Symantec reported that there is database inconsistancies and when I check the instance, the database snapshots are in restoring status. What should I do to resolve the problem? Can I drop and recreate the database snaphots? How to know whether is there any connections to that database snapshots?
Backup
(1)
Database
(1)
YesHow
(1)
Inconsistancies
(1)
Symantec
(1)
Snaphots
(1)
Msdb
(1)
Amd
(1)
Uri Dimant replied to noorhayati shamsuddin
Yes
How to know whether is there any connections to that database snapshots?
sp_who 'active'
amd looking at dbname column
Question of backup database SQL Server In SQL Server 2005 there is a new options called NO_LOG in backup database statement which is used to take the database backup without transaction log. I used the NO_LOG option to take the database backup and backup completed with the following message. backup database FileDB to disk = 'c: \ temp \ dbbackup
Differential backup with no full backup? SQL Server When you perform a differential backup and a full backup doesn't exist you get this error message. current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option." This is good. However it seems
Insert date into filename during backup SQL Server I'm currently doing differential backups via the following scheduled job command: BACKUP DATABASE [DATABASE] TO DISK = N'c: \ backup \ DATABASE- Differential' WITH INIT , NOUNLOAD , NAME = N'DATABASE differential backup', NOSKIP , DIFFERENTIAL, STATS = 10, NOFORMAT However, I'd like to do the backups several times
backup an instance SQL Server hey all, i'm looking in sql books online at the backup database command and saw the following example: - - Back up the full AdventureWorks database. BACKUP DATABASE AdventureWorks TO AdvWorksData how do you tell it which instance of sql you would like to use? thanks, rodchar SQL Server Programming Discussions SQL Server (1) Backup (1) AdvWorksData (1) Database (1) AdventureWorks (1) BSc (1) PhD (1) Toronto (1) It uses the instance to which