Viewing 15 posts - 4,516 through 4,530 (of 7,191 total)
That's another option, but it has the disadvantage that you still need the vendor to send you back the whole database instead of just a script. I'd be interested...
May 21, 2012 at 4:51 am
That means the live database is out of action all the time the third party is looking at the copy of it. Do your users accept that? If...
May 21, 2012 at 4:34 am
forever20xx (5/20/2012)
Firstly, via SQL Central Administration -> Operations -> backup & Restore -> Sharepoint Farm Backup -> Full Backup
Secondly, via the SQL...
May 21, 2012 at 1:45 am
Backup and restore does not rebuild indexes. The only way it may help is by reducing physical fragmentation, but, conversely, it may also increase it. My advice would...
May 18, 2012 at 4:58 am
OK, thanks for posting back. Turns out that you were specifying the same physical file twice in the same RESTORE statement.
John
May 18, 2012 at 4:22 am
forever20xx (5/17/2012)
May 18, 2012 at 1:42 am
The plot thickens. I followed the link that Dwain posted but there was nothing in the terms and conditions about stored procedures.
I shudder to imagine how you go about...
May 17, 2012 at 4:16 am
Well, that isn't the only resource available. I'm sure your search engine works just as well as mine does.
Are you using a format file? That's the way to...
May 17, 2012 at 4:00 am
That's interesting. What exactly are BT hosting? Is it the database? Is it a database that you wrote, or one that they have provided for you? ...
May 17, 2012 at 3:47 am
There's tons of information about this on the web. Here's an example:
John
May 17, 2012 at 3:08 am
I'm staggered. How can it be more secure to have to grant access to all tables and views for querying, instead of just execute permission on the stored procedures?...
May 17, 2012 at 3:04 am
If that works for you, then that's the simplest thing to do and you should keep doing it. But rebuilding indexes can cause significant log file activity and so...
May 17, 2012 at 2:45 am
MySQL isn't exactly the same as SQL Server, I'm afraid. You'll need to get a more appropriate book, or find some way of translating MySQL code into T-SQL.
I still...
May 17, 2012 at 2:39 am
See that error number 64? If you go to a command prompt and type net helpmsg 64, you'll get a description of what the error means. In this...
May 17, 2012 at 2:37 am
One thing you could try, depending on how often you rebuild your indexes, is to stop the log shipping jobs before the rebuild starts, then restore the whole database on...
May 17, 2012 at 2:14 am
Viewing 15 posts - 4,516 through 4,530 (of 7,191 total)