You can allow the secondary server to assume the primary server role provided that you selected the Allow database to assume primary role option for the secondary server during the...

Hi

SQL Server 2008 and Windows Server 2008 provide a highly compelling solution for security, compliance, and high availability.

Recently I have installed SQL Server 2008 on Windows 2008 server bot...

Thanks John, I did follow that and it installed successfully.

I have the same scenario here ....

ETL package to load of data insert are taking in table "history_info" and

then these data are compared with other tables so again a...

1.Check the RESTORE FILELISTONLY to find how many data & log files are there in your backset.

2. You might have appended to the same backup device thats the reason...

Hey Lutz and Drew thanks for the suggestion. 🙂 . I had been trying out this query and finaly it worked :-D. I would have shared the DDL and sample...

Hi John,

My req. is that I want to display all the tickets which have min addnote time within the one hour of ticket creation. I am trying the query in...

Jeff Moden (7/17/2009)

---

You may be able to use a disk utility to try to "undelete" the file, but chances of that happening on an active system decrease dramatically with every...

I think this will work

There is FIX available for this issue check the following link:

http://support.microsoft.com/kb/941689

isabel (7/9/2009)

---

In our company, we are using several servers, but :

we want to backup our database from the production server which will be directed and restored to our report server,...

isabel (7/9/2009)

---

In our company, we are using several servers, but :

we want to backup our database from the production server which will be directed and restored to our report server,...

I dont think so you can restore an oracle dump in SQL Server but you can migrate oracle DB to SQL Server using migration tool.

Thanks Steve, for the suggestion. I created a maint plan that backup daily to SAN and after that another backup to Tapes using Tivoli.

But my Tivoli backup fails with...

Thanks for the reply.

Planning to use Tivoli backup software. what parameter shall I consider? What is VDI backup in SQL Server?