I'm sorry if this is a stupid question, but did the job fail? Individual steps can be set up to continue even if a step "fails". The whole job...

If you're just moving a secondary log file...

1. create a new log file in the new location.

2. Do a shrinkfile with EMPTYFILE option on the log file that is...

Based on what you are saying you have all the partitions on one physical drive or a set of physical drives(raid).

What you can do is add more drives...

abdul.samad.121 (1/28/2011)

---

yes you are absolutely correct , I have copied the model.mdf and modellog.ldf to some other location to create scenario as if the model data and log files have...

I would ask your server(SAN) team to create a separate LUN and create a new drive for you. Request that they create the LUN from a totally separate set...

You might want to look at lower performance drives. I know we use SATA LUNS for stuff that people don't care about at least in performance and they just...

While I agree with the other posters that you should have more than 1 backup...

But should you want to continue..

In the maintenace plan, if you choose

Backup to databases across one...

Since its in a different step. You can change it to powershell and use the following:

$FileInfo = Get-Item <Path><File>

$FileInfo.Length

nari.koud (9/10/2010)

---

Hello All...

I have a database XYZ (Full Recovery Model,300 users in it size aroung 134800 MB,) on Server 1(dev)

I need to back it up to some location(z drive/disk)

...

Just an update:

A ticket was open with Microsoft support and they confirmed that they can reproduce this issue and are having the developers look into this issue.

I will update this...

OK. More testing done today and this is what I encountered.

1. Created a new database called "Test" with all defaults.

2. Backup database to file called "test.bak".

3. Check logical file name...

COOL_ICE (9/6/2010)

---

Hay Steve,

It is sounding very strange!!! Is this issue is with only database or is it happening to all databases across the instance? BTW, which version of SQL...

jeff.mason (8/5/2010)

---

Only...

Just because you delete the data, it does not return the space to the operating system. ...

Local temporary tables are discarded after the connection to the server is closed. If the connection stays open, the tables will stay in tempdb. Additionally if you are...