Other option is, database backups are taken by MSFT and maintained, you can restore individual databases using powershell commandlet Restore-AzSqlInstanceDatabase

Hi Jeff,

To start with Merry Christmas and Happy New Year

I came across a situation where I have to invoke parallel sessions and that has to be done through query window...

murthykalyani (10/31/2013)

---

I haven't comeacross CXPACKET waittype while inserting data.

Mostly sql server decides whether to execute the query on parallel threads or not, based on the estimate time the...

I haven't comeacross CXPACKET waittype while inserting data.

Mostly sql server decides whether to execute the query on parallel threads or not, based on the estimate time the query completes i.e...

AKP (3/1/2010)

---

thanks for your quick reply. But I am wondering that whether the OLD disk have some configurations attached with SQL SERVER ENgine. IS there any better plan this mine...

AKP (3/1/2010)

---

Hi Guys,

We have a disk space issue on one of the drive where SQL Server files are located (system dbs,user dbs and others). We are planning to replace this...

Extract the login and sid information from the primary server through sp_help_revlogin, drop the sql server login on the secondary server and recreate the login with the login information that...

Greg Charles (1/27/2010)

---

Our backup jobs have a step for each database. That makes it easy to continue if a step fails by setting the on failure action to 'go...

SQL_Hacker (1/26/2010)

---

The join is not occuring on the oracle server at all. It is occurring with a linked server, and if I leave out the table from Server1, I...

Can you initially get the required data from the linked server through open query if possible and then do a join on the server?

Are you trying to join a table in oracle to tables in sql servers with in the stored procedure?

SQL Server divides total memory to two components 1) Buffer Pool

2) MemtoLeave...

Why do you trying taking a single database backup through litespeed manually and see what happens?

There is an active transaction and is still opened before completion of backup. For this reason it cann't make these transactions inactive.

Agree with you, but the...

You can get the details from restorehistory table in msdb database or from error log, or application log.