since its a dedicated SQL box so you can rather you should allocate\reserve good amount of memory to SQL so that sql operates optimally & provides good performance.

otherwise SQL has...

and don't forget to check save password checkbox.

Bhuvnesh (3/3/2010)

---

Here i am talking about...

Mike Levan (3/2/2010)

---

Ours is a dataware house environment currently using sql server and planing to migrate to Teradata as it is very robust and can handle our environment very effeciently.

I...

Just to add to gail's points

You can also take the tail log backup if master DB is corrupted but ldf file of the user DB is still available.

checkout this...

Sumanta-1056020 (2/15/2010)

---

Hi,

We have SQL server 2008 and using clustering environment with 2 nodes. One .net application connects to this server. But sometimes we get the below error from the...

JSteppenwolf (3/2/2010)

---

I'm searching for a best solution to replicate a 600GB database in a production server to a Reporting server on a weekly basis.

Hoping that someone has experience with large...

Thamizh (3/2/2010)

---

Hi all,

Any one give some word about this,If i run the procedure in test server it performs good.The same implement in the production server running very slow .I...

I think you should change it from AD.

you need to create a SSIS package to search & select a backup file

you can use the below mentioned query of REDGATE which can be used to restore the DB.

EXECUTE...

You can restore the backup of pub DB with another name (can be myDB)

but if you have a DB already created, it is not at all possible to restore backup...

Hi

Both the SQL Server installations should be of either 64bit or 32bit.

i've seen instances where SQL Server Linker Server works fine in one way but failed to connect the other...

Hi,

The SQL Server Management Studio Standard Reports – Schema Changes History Report of the Respective DB can help you in identifying who changed this setting and when.

Cheers!!!

Like Gail Shaw said: If you have never taken a FULL backup of your database, log backup of that database will also be not available.

To Double-check:

You can query an...

fjmorales (12/9/2009)

---

I created a MK and a Certificate to encrypt data and it works fine on the development server but once I moved the DB to the production server decryptbycert...