Re: Split Mirror backup and restores

From: Hassan (fatima_ja_at_hotmail.com)
Date: 09/13/04 

Date: Mon, 13 Sep 2004 14:58:44 -0700

Well the minute you attach the mdf and ldf files, the databases are
recovered and you cant even apply any T-logs henceforward to take it to a
point in time. Not used Veritas product before.. just talking with regards
to the native attach/detach within SQL Server

"bstevenson" <bstevenson@discussions.microsoft.com> wrote in message
news:D3845EF9-79F1-4591-AA5C-D39812896D5F@microsoft.com...
> We are implementing Veritas Volumn Manager 4.0 on a Windows 2003 server
> running SQL 2000. We will using the flashsnap plugin to do full database
> backups and using SQL to do transactional log backups. My question is how
do
> I do a point in time recovery when I am not restoring my database from a
> backup file. In essence I am attaching the mdf and ldf files that were
> snapped when the mirror was split.
>
> Thanks,
> --
> Bill Stevenson, MCDBA, MCSE
> SQL Server DBA
> PeopleSoft Enterprise System Administrator
> PeopleSoft Enterprise One CNC
> IBM Certified Specialist - DB2 V7.1 User
> ACS - Application Management Services

Relevant Pages

  • Re: register database
    ... MSDE will not come up with normal tools graphical tools. ... This will go go to a sql prompt, there execute the sp_attach_db to attach ... This will attach the database to sql server. ...
    (microsoft.public.sqlserver.server)
  • Re: visutal studio.net 2005 debugging question
    ... version to debug with a sql server 2000 database. ... My goal is to debug some t-sql commands. ... attach to a process and the process that I need to attach to is ...
    (microsoft.public.vsnet.debugging)
  • Re: SPS - SQL Server - LOG FILES.
    ... After restarting the SQL Server and IIS services ... "Unable to connect to database. ... these log files are using lot of space on c drive. ... > LDF files are log files for SQL server. ...
    (microsoft.public.sharepoint.portalserver)
  • LOG Device Corrupted
    ... sp_attach_single_file_db to attach the DB device to new sql server. ... Could not open new database XXXX, ... I tested use another DB to detach and delete the log file, than attach it ...
    (microsoft.public.sqlserver.server)
  • Re: SqlServer 2005 Transfer Flame
    ... I can't use the attach and detach method because I don't have sufficient rights on the source databse (it's on a shared hosting ... valid user in database 4restore ". ... SQL Server 2000 and SQL Server 2005. ...
    (microsoft.public.sqlserver.dts)
Loading