Is anyone using sql server 2k virtual device interface for a quick backup and restore? I am trying to find a way to do a quick restore daily on a database that is about 40 gb in size so that it can be used to run reports on. right now it takes four to five hours to restore. If someone can point...
All,
I am restoring a table but running out of space in the file system. Can I stop the restore move the files to a larger file system and restart the restore at the point I stopped? The restore has been running almost three days. I am a newbie to Postgres and just following a vendors...
Are there any tools in Sybase ASA 8 or 3rd party that would allow me to monitor performace in ASA 8? How would I use them? I need to monitor for a stress test we are doing in the near future and I have not been able to find any information.
Thanks,
Dave
I have a user that would like to monitor jobs in sql server. How can I set this user up to monitor jobs using EM without giving him the sa role? I tried to set permissions on the sysjobs, sysjobhistory, sysjobserver and sysjobschedules tables in msdb but he still couldn't see the jobs.
Thanks,
Dave
I need to add a column to an existing table that contains data. This column will also become part of a concatanated primary key for the table. I would like to put this column next to the other columns that make up the key. I know I need to export out the table, drop the table, change the CREATE...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.