Talk to your SAN team and vendor - they may have better solutions for producing replicas that you can use for your situation.

Also, you may want to investigate upgrading to...

Dynamic SQL is the better choice in this case - however, the way you have approached this has created a potential issue and opened that procedure up to SQL injection.

You...

Denise McMillan (3/18/2013)

---

I found the problem. I had to put the drive letter in the path name. Like:

\\servername\d$\foldername\filename.txt

Thanks to everyone for taking the time to help me with...

Make sure the SQL Server service account has access to the share. If your agent job is running as a sysadmin user it actually runs in the context of...

You really don't want to be building your searches this way. What happens when you change from a datetime data type to a datetime2 data type?

You will then be...

When you installed SQL Server 2008 - did you install with the default Service SID?

If so, then your domain account running SQL Server agent does not have access to SQL...

What is the error you are getting?

I am going to guess that you are getting an error similar to SSPI cannot generate context. If so, then your problem is...

A couple of points:

Verify that the version of your client tools are the same or greater than the version of SQL Server you are connecting to. These kinds of...

Since you are going to restore the database anyways - this will work:

ALTER DATABASE {database} SET OFFLINE WITH ROLLBACK IMMEDIATE;

Take the database offline, perform your restore - and the database...

Litespeed does not store anything additional over what is stored by native backups in msdb.

With that said, Litespeed can be configured to stored history in a repository which is either...

Check for an active transaction in the other databases - especially tempdb.

Unless your non-clustered indexes actually include the LOB columns, they can...

What OS did you upgrade from?

touchwithme2 (11/18/2009)

---

Hi,

It was quite good to follow...i have query on this, whether we can move the temp db in production server on business hours.

Plz update on this ....

Waiting for your...

I guess I am confused by that...

All instances installed have to have a name - whether it is the default instance or a named instance. The default instance has...