This site is one of the best. It has always been a great learning tool and help site for solving problems. Glad that it will still be around and great...

We looked into snapshots, but the problem is the database would grow too big to fast to be an effective solution, and the database is nonupdateable during the snapshot times....

I am also having problems with this issue. The problem with us is the databases were auto created by our sharepoint system and many of the tables created do not...

I ran into this problem too. I opened the csv file in a text editor (free one is Notepad++) saved it as a .txt and was able to import the .txt file...

I will have to let our IT director ping it. This is at a remote site outside of my firewall and within a different firewall. I was thinking that what we...

we found that a user had placed a database, dts scripts and sp's onto his pc to run production jobs. Attempting to add a new server registration with Enterprise Manager has failed. It cannot find...

The databases attached can be placed into offline status. Still there but not running.

Are you trying to set up the server as a recovery machine for a hot swap when the first one...

Did you stop the service and copy the .mdf and .ldf files  or detach the databases and copy the .mdf and .ldf files? The second way would be the best...

When I  started my new job as DBA,one of the first things my boss had me do was build a SQL 2k5 machine for test. We have had this setup for...

Thanks for the advice.... the c: drive is 15G so I will leave things as they are. Just being overly cautious.

Thanks! I will check these out. I did purchase two books recommended on the microsoft site to get started, and I was wondering if that was enough.