You want to know backup file sizes?

This link should be a good begining.

http://www.sqlservercentral.com/scripts/Miscellaneous/30338/

mail4sha (9/20/2010)

---

thanks a lot for reply.... can i store this log in any file? i mean can i create my own error log file? logging my desirable information not only...

nuthan_kumar (9/20/2010)

---

I have a abc.mdf file of sql server 2000 and now i am trying to attach it to sql server 2008.

and getting this error.

exec sp_attach_single_file_db @dbname ='abc', @physname='c:\abc.mdf '

"Database...

let the script zip the files in asynchronous mode, a seperate zip process will be created for each file EXCEPT the current file. just dont touch the current file. this...

Perry, the link doesnt work for me. i guess the underlying uRL is...

in fact its good to have it written in powershell 🙂

I suppose vbscript would have faced the same issue - of zipping asynchrous.

may be you can write the move...

shew (9/16/2010)

---

I'm looking for ideas for how to zip up the old .trc files and move them to a different server for storage. Unfortunately, the audittrace*.trc files appear to be...

you have to specify the owner name of the SP if the owner is not dbo(which is the default owner).

i think you should go with the option you suggested - isql.

on server 1, job step1 should run on current server and job step 2 should call a command line/batch...

recreate the publication and then remove it. then proceed to drop the db.

Lowell (8/19/2010)

---

i'm very sure you need to simply change the c2 audit setting, then just stop and start the server;

i've done it quite a few times, and that's all i...

Thanks for the feedback. Will implement...

Yes. but i knew little powershell at that time. I also use...

Thanks Brian. I will ask the user to connect using using IP and provide you with the results.

I'm not a coder. If you're able to connect via SSMS, you shud be able to connect via ur application.

I read that link u provided.

find the IPaddress of your local...