Sounds like permission problems on the folder where your are trying to create the data files.

Hope this helps.

Try BoL.

use msdb

go

select*

fromdbo.backupset

This should be all you need.

http://msdn.microsoft.com/en-us/library/ms188748.aspx

Sounds like schoolboy error from MS! Perhaps they should have used where sid = 0x01 and not...

Without knowing more about your reporting requirements, advice will be very high level.

One solution could be to produce monthly "snapshot" reports, after which, your data can be removed. From this,...

Markus (10/30/2009)

---

Problem is we have a lot of purchased apps that REQUIRE to install you use the sa login to install it. In that install process it will create...

george sibbald-364359 (10/28/2009)

---

personally I would not leave applying service packs up to wsus. What about closing down apps before the install and backing up the system databases so you have...

Michael Valentine Jones (10/1/2009)

---

This script is used to shrink a database file in small increments until it reaches a target free space limit.

Shrink DB File by Increment to Target Free...

Hi.

You don't say what the client expects to use the database for but as you are restoring diffs, I am assuming they are accessing this as read only.

If your client...

I have seen this before but cannot remember exactly what the problem was ...

What is the output when you run RESTORE VERIFYONLY against your log file?

What is the output...

What is the output from the SQL below when run on the primary server? This should give the last 10 log file backups.

On the primary server, what is the time...

One other thing.

If you move your processed log shipped files out to another directory, does your restore latency drop or stay the same. Interesting ...

Two things to check:

What is the time difference between the name of last file to be copied and the system clock? This should be only a little more that the...

Here's a tip I picked up some time ago that I always use regarding Domain Admin, Local Admin and SA.

Create domain groups, populate accordingly and grant equivalent rights to the...

Stick the following into Google: sql server how to script database logins

This is the first one in the list and should do what you are asking for.

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