Viewing 15 posts - 4,456 through 4,470 (of 6,679 total)
GilaMonster (10/16/2009)
GSquared (10/16/2009)
Of course, if that particular page was affected by some transaction in the lost file....
As far as I'm aware, it doesn't matter. With a missing log file, the...
October 20, 2009 at 3:59 pm
Are those tables in a different database? If so, then you would have to create the user in the other database and give them access in that other database...
October 20, 2009 at 3:51 pm
Yes, if you are going to be altering the database in any way - that is going to eliminate a lot of possibilities and make the process much harder.
You can...
October 20, 2009 at 3:38 pm
And, only if you have a current backup. Until the database is backed up for the first time - the transaction log is in a psuedo-simple mode where it...
October 20, 2009 at 2:54 pm
jrw39 (10/20/2009)
GSquaredthanks, one more question what does the CTE represent?
CTE is Common Table Expression. You can look it up in Books Online for further information, but generally it can...
October 20, 2009 at 2:46 pm
Review the SSIS packages - on the OLEDB destination you want to validate that you have set a batch size and a commit size. Setting these should help reduce...
October 20, 2009 at 2:37 pm
I would look at using Hyperbac myself. Or, you could look at the various products available from Redgate, Quest, Idera, etc... that perform backups and allow for compression.
Using Litespeed,...
October 20, 2009 at 1:40 pm
Chuoi Tieu (10/20/2009)
Fantastic. Thank you very much. I get it working now. I use REVOKE instead and it works fine.Thanks,
There is absolutely no reason to do anything in Public. ...
October 20, 2009 at 1:19 pm
peterzeke (10/20/2009)
October 20, 2009 at 1:15 pm
If you were not done - then you have to start the restore over.
October 20, 2009 at 1:10 pm
repent_kog_is_near (10/20/2009)
Thanks for the points. I have never used mirror before. Do I need one extra server to host the mirror?
Would there be benefits to doing DB snapshop instead of...
October 20, 2009 at 12:13 pm
Dan,
For item 1 - yes, those are the technologies I was talking about. And, no - you would not be hitting the original (production) system because the database snapshot...
October 20, 2009 at 9:49 am
You probably are running in a parameter sniffing issue - review the following article by Gail (follow the links for the other articles also): http://sqlinthewild.co.za/index.php/2008/05/22/parameter-sniffing-pt-3/
You can also verify the connection...
October 19, 2009 at 2:31 pm
Jeff - without knowing which SAN it was, it's hard to say what is actually possible. For example, I have two types of SAN's available. Netapp and HP...
October 18, 2009 at 10:57 am
If you are running Enterprise Edition on your reporting server, you can create a database mirror and a database snapshot off of the mirrored database.
Perform the db snapshot every 4/6/8...
October 18, 2009 at 10:24 am
Viewing 15 posts - 4,456 through 4,470 (of 6,679 total)