.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Quiescing the MSSQL database and Split Mirror Backup

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :
Hi All,
I am trying to implement a backup solution for SAP system on MSSQL database. I have two questions related to the strategies:

1) In Oracle using the BRTools we can implement the split-mirror backup solution, is there a way to implement split-mirror backup solution for a SAP systems on MSSQL database?

2) How do we quiesce the MSSQL database of an SAP system to get the split-mirror backup? Does Quiescing the MSSQL database for an SAP system applicable or its not applicable at all for SAP systems?

It would be really helpful if some inputs are provided on this topic.

Thanks and Regards,

View Complete Post

More Related Resource Links

MSSQL 2008 R2 - database in restoring mode after backup - forever..

Hi folks,   i have this problem that occourred today with one instance of MSSQL 2008 R2 running on a WIN x64 R2 enterprise server.   i have run a backup maintainance job and now i have two databases in restoring mode for over 4hrs.   my questions are: why are these databases restoring when i was backing up? and why are they not being logged anywhere - i can not find anything on logs, activty monitor, or even Windows Resource Monitor.   i can not see any work been done by MSSQL to restore these databases, and yet they are set as 'RESTORING'.   any suggestion from the community here will be much appreciated as i am banging my head against the wall already.   thanks,   Nicolas    data warehouse | data migration | ETL/ELT | UK | http://www.brainpowered.net

Restoring a Content Database to an earlier MSSQL backup?

We'd like to roll back a content database to an earlier point in time. Is this doable by just shutting down the frontend, and then restoring the MSSQL WSS_Content database, or are there some quirks that we need to take into account?

SQL2008 - Cannot Restore a new database from a full backup of a different one, database in use

I am trying to restore a brand new database from a copy of another one and am encountering an error message stating: System.Data.SqlClient.SqlError: The file <Backup source database file location> cannot be overwritten.  It is being used by database <Backup Source Database>. (Microsoft.SqlServer.Smo) I am running the Restore procedure with the REPLACE option and am wondering why it is stating that the source database is the database in use when I am trying to restore and overwrite a completely different database. This issue happens when running the replace both in C# using SMO and when manually restoring with SqlServer Management Studio Interesting note is, the original source database is created / deployed using a database project within VisualStudios 2010 and then deployed to SqlServer through VisualStudios. Any thoughts on why this is happening? Thanks in advance for any help!

Can't restore database backup file in my database ? using sql server 2005. please help

VERY IMPORTANT i am trying to restore database.bak in sql server 2005 (i know the database.bak was also generated in sql 2005 server) i am trying to restore back up database .bak into the new database i just created in sql server 2005 i have saved my database .bak into c drive and when i select database .bak "From Device", it doesn't get populated in the list below and i see nothing and it keeps on prompting a message "You must select a restore source" Here's the screen shot:   PLEASE HELP..it's really important (i tried restoring database in sql server 2008 and it was sucessful but i am facing this problem in sql server 2005 only)  

How to Include Password during Database Backup over Tape

Hi All, We have EMC Backup Solution in our organization which does backup of all the databases. I want to know is there any way that i can include the password option whenever Backup runs. I dont want to modify any script at the EMS Backup solution side. I want to do it on the fly.         Mohd Sufian www.sqlship.wordpress.com Please mark the post as Answered if it helped.

Is there a way to backup all my store procedures under a particular SQL 2005 database?

hi all, Is there a script, doc, VBS script, SQL statement out there which will read all my store procedures and save them as a TXT file? Currently I have to save all of them in text files before I update them when I get a new web site release. Thank you  JCD

how to restore msdb database on sql 2008 from sql 2005 backup?

Currently, I am unable to do it. It gives me the error than I cannot be restored because it was created by a different version of the server. What is the work-around? I hate scripting all my maintenance plans and alerts, there are tonns of themJulieShop

"The backup set holds a backup of a database other than existing database. Restore Database is term

I have a problem when i restore my .DAT_BAK file.  I am getting error like "The backup set holds a backup of a database other than existing database.  Restore Database is terminating abnormally".   I tried by using   RESTORE DATABASE <DATABASENAME> FROM DISK = 'D:\DATA\MYTEST.DAT_BAK' WITH MOVE 'VZAI_DATA' TO D:\PROGRAM FILES\..\MSSQL\TEST.MDF', MOVE 'VZAI_LOG' TO D:\PROGRAM FILES\..\MSSQL\TEST.LDF', REPLACE   And also i tried like   RESTORE DATABASE <DATABASENAME> FROM DISK = 'D:\DATA\MYTEST.DAT_BAK' WITH REPLACE   When i use like this,   RESTORE FILELISTONLY FROM DISK = 'D:\DATA\MYTEST.DAT_BAK'. I am able to get the output as LogicalName, PhysicalName, Type, FileGroupName, Size, etc.   Can i anyone please help me out?   Thanks in Advance, Anand Rajagopal

calculating the size required for backup of database

Hi, How to calculate the size required to take backup of a database in mssql 2000.the results returned by sp_spaceused differ too much from the actual size taken on the disk. Thanks in advance

: Exclusive access could not be obtained because the database is in use.could not applu log backup f

I have 50 databases all are log shippipped.i am getting below error for some databases some time 2010-09-07 15:45:21.04 *** Error: Could not apply log backup file '\\ds\M$\CT_20100907190004.trn' to secondary database 'dsCT'.(Microsoft.SqlServer.Management.LogShipping) *** 2010-09-07 15:45:21.04 *** Error: Exclusive access could not be obtained because the database is in use. I have selected option to disconnect all users when database is in restoring state also. Backup is schedule to run at every hour suppose 12 copy will run at 12:15 and restore will run a 12:45pm. Urgent because i am getting this error on all servers  

Any idea about how to do photo capture from webcam and save it to database MsSQL server

i would like to do a project that enable to capture photo from webcam, and record audio from microphone store to database. but the photo and audio store in folder and the database only store the filename. later i set the path and its play back the audio and show the photo.thanks

Full database backup takes so long

Today several full database backups took so long. Normally it took 2 hours to backup. But today the 5 backups didn't finish by the end of the work day. The backups went well until yesterday. I don't know what happened overnight. Is there a performance tool embedded in SQL Server? How can I find out why the backups take so long? What could be the possible reasons? Thank you,  

Backup Database

Is there a way to execute Backup Database ONLY on the condition that nothing has been updated inserted or deleted? Thanks  

Full Farm Backup Fails on Windows Sharepoint Services Search Database

I am just now starting to us central administration to backup the entire sharepoint farm.  All content backups fine except for the Search Database.  In looking through the backup log, it appears that the search database may not exist.  How can I determine if the search database actually does exist and if it does not can it be recreated?

need information on database backup

Hi, As a developer Ihave very minimal knowledge on database backups. Before reaching out to DBA I want to understand few things 1) I need to place a request to create new database on a SQL Server. There is around 540 GB space on this server but the two existing databases on this server already used 500GB space. So what option do we have to create new database? Is it a simple task to add another drive and allocate some space or use mapped drive? what options can I suggest DBA? 2) Also DBA mentioned that there is no space to take backup on this drive for the existsing database. What option can I suggest for backup incase if we plan to drop one of the database which is not actively used?

VS2010 Deploying Database Project - Error: Cannot create file [...]MSSQL10.MSSQLSERVER\MSSQL\DATA\m

I had SQL Express from a previous installation of VS2010. I uninstalled All SQL and VS2010 and re-installed VS2010 (without Express) and then re-installed SQL Server 2008 Developer Edition. Now when I try to deploy a database project I am receiving the following error:     Creating EDDY.Cheetah.Database.Server... ...\sql\debug\Server.sql(38,0): Error SQL01268: .Net SqlClient Data Provider: Msg 5170, Level 16, State 1, Line 1 Cannot create file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf' because it already exists. Change the file path or the file name, and retry the operation. ...\sql\debug\Server.sql(38,0): Error SQL01268: .Net SqlClient Data Provider: Msg 1802, Level 16, State 4, Line 1 CREATE

database backup

Hi, i have a problem with database backup. i want to backup database which is in another domain to my local  system. please solve this problem ASAP thanks in advance
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend