Saravanan_tvr (8/4/2010)

---

Dear all,

We have a database with full recovery model, so the logs are growing very faster, so if i shrink the database base its not shrinking especially LDF

Like a...

I think this is more of a security question and so I will re-post this in the sql security section.

Maybe the network card is getting saturated? Maybe the backup file is bad. I would try making a backup of northwind or create a new database and then backup...

SequelDBA (6/17/2009)

---

I am experiencing a similar issue, although we are using SQL 2005 SP3, Windows 2003.

We are attempting to refresh our Dev database from Prod. The backup is about...

Steve Jones - Editor (6/11/2009)

---

I would not back up to remote drives directly. If there is any network hiccup, your backup will fail, and that will be the day Mr....

I've created the backups and they appear to be running OK (for both simple and full recovery mode). When I come to do a restore of a simple recovery...

Garadin (11/11/2008)

---

SQL DBA 808 (11/11/2008)

---

Steve T: Yes. That's very close to what I need to do. Thank you.

Garadin: I will read that and see if I...

Sounds like a bank/credit feed file. There's probably no data structure other than 2 columns. 1 for the header record you manually added and the other is probably the actual...

Doh. I didn't even think about that. Thanks for the example.

Wow things you don't unless somebody tells you. Thanks!

pduplessis (6/10/2008)

---

hey,

Why dont you first write a query, "select distinct len(emp_id) " to check at the various lengths that you have?

Possibly the length is being reflected as the maximum length.

Also,...

Go to Surface Area Configuration for Features

click the checkbox...

kevin77 (4/18/2008)

---

Is there a way to throttle a database backup? Everybody says to do a "local" backup first, then copy those files else where. The problem is, we...

jsheldon (4/21/2008)

---

We have to push .bak files from our SAN server to a warm server. Log Shipping, Mirroring and Replication are not an option due to the antiquity of...

shahab (4/18/2008)

---

I am getting following error when restoring the db:

The database 'ABC' is marked RESTORING and is in a state that does not allow recovery to be run.

whats going on...