Viewing 15 posts - 391 through 405 (of 456 total)
For the two active nodes to run different installations of SQL would I have to use named instances?
February 19, 2008 at 4:41 pm
My limited knowledge of access tells me that there is no ldf file...just an .mdb i am not an expert in access though
February 18, 2008 at 10:00 am
It seems from what you have said the 3rd party product is not backing up the SQL database but trying to backup the actual files in the file system. which...
February 13, 2008 at 9:42 am
Following on from the previuos post, you could save your index rebuilds until the weekend, but if index fragmentation is a problem then you could rebuild online during the...
February 13, 2008 at 9:20 am
Hi thanks for the repsonse,
Just a few extra questions.
I thought that C2 was at server level and it captured everything. Is it possible to configure what data is captured or...
February 5, 2008 at 9:57 am
I've only really used Redgate's SQL backup aside from the native client...i found it be very good in terms of speed and compression.
February 1, 2008 at 1:35 am
Hi Kerry,
Re-installing windows then reinstalling SQL Sever and then restoring the user DB from the BAk file, you will have a database that no users can access, no logins will...
January 30, 2008 at 8:05 am
This link might help you start...
http://www.microsoft.com/sql/prodinfo/compare/oracle/default.mspx
don't know too much about Oracle training material though sorry. I'm sure there's a similar range of books out there that SQL Server...
January 29, 2008 at 9:11 am
sorry for stating the obviuos can you not simplydelete files older than two days?
January 29, 2008 at 9:07 am
will you need to rebuild/restore the system databases too?
To restore a user database you don't need to create a database first , you can restore straight from the backup...
January 29, 2008 at 9:03 am
OK well not th most detailed post but if you want to list all the uset database on a particular server then this will list them also it will provide...
January 27, 2008 at 2:23 pm
You could drop the indexes before the bulk insert and rebuild after the insertion. the insertion will be quicker becuase it will not have to modify the indexes on each...
January 26, 2008 at 6:39 am
you can detach - reatch or even backup and restore. Even though backup and restore will "avoid downtime" there is the possibility of the database not being in sync. i.e....
January 25, 2008 at 4:30 pm
backing up msdb database will backup your agent jobs, its also a good idea to script them out.
January 25, 2008 at 4:24 pm
Viewing 15 posts - 391 through 405 (of 456 total)