Name Data Log Size Recovery

Database1 512 384 7168 Simple ...

🙂

Mark Shvarts (10/7/2008)

---

Luke clearly explained what I mean by off hours.

I recommend DBCC shrinkfile over shrinkdatabase because you can do shrinking more granularly. As you have indicated above, you...

I don't know if this what I want to do, I need an advise. I am trying to transfer servers from 1 location to another in total of 300 GB...

It is run within a vbscript, it appears to do some type of maintance on the commerce server database

How do I know Desired size? Thank you

Why would you better recommend me one file at a time (DBCC shrinkfile) and not (DBCC shrinkdatabase)?Thank you

We don't have off hours. Our server for the web and we have to operate all the time. So, I am trying to see my options. What else can I...

You said I can remove the free space before I backup, How?

Yes

I have a RedGate tool and I am planning to use it when I get the full back up from them. Do you know what can they do not to...

Will I loose anytime for users to use databases? I can loose anytime, my server needs to operate all the time. Can you shrink server or just db? Thank you:)

Before we get the server, can we shrinked it without any time lost,so it would take less time for me to do a full backup?

We are running out of space, I thought it could be a good ideai shrink databases and we could have more space

Thank you, but what should I check on the server side for configuration?

Thank you. I was told that we can do a full backup and move it to the new server and when we ready to go life copy the latest transaction...