Viewing 15 posts - 46 through 60 (of 62 total)
You can only use the OS restores of the mdf and ldf files IF SQL was offline during the OS backups or if the database was detached from SQL.(or a...
December 1, 2011 at 7:01 am
I know this doesn't specifically answer your question, but you'd be better off adding the service accounts as explicit logins and granting them sysadmin the adding back the build-in group....
November 30, 2011 at 6:58 am
The answer to your issue is B: The backup of the msdb system database is at an earlier revision than the current version i.e sp3.. to sp4.
November 29, 2011 at 12:38 pm
You can review the restore history in msdb to determine the last successfull restore. If you still have access to the log files, you can just pick up from...
November 29, 2011 at 9:00 am
I should stress the fact that this will absolutely replace every occurance of the 1st character with 2nd character everywhere it exists in that column. So if that's not...
November 28, 2011 at 1:41 pm
update [table_name] set [column_name] = REPLACE([column_name], '"', '+')
November 28, 2011 at 1:36 pm
As was already suggested, look at the SQL Server Error Log and post the entries from the log when the backup failed. You can also review the eventvwr in...
November 23, 2011 at 12:55 pm
We don't really have enough information to make many suggestions. There are 3rd party utilities that allow you to sync file systems, so everytime the data file (not the...
November 23, 2011 at 12:41 pm
If you're not familiar with SQL, the easiest way would be to create a maintenance plan using the wizard. The wizard will basically walk you through the whole process...
November 23, 2011 at 10:41 am
Depending on what you have the ability to change or implement, there are many different options. Log shipping or database mirroring + log shipping. Moving to SQL 2008...
November 23, 2011 at 8:55 am
The original post asked how it would be done if the primary has gone down. If the primary is truly down or in a failed state, there isn't anyway...
November 22, 2011 at 5:33 pm
If all of the logs are already current, all you have to do is issue the command I previoulsy listed. Otherwise, you need to apply any outstanding logs and...
November 22, 2011 at 4:12 pm
You're most welcome. Glad to help.
November 22, 2011 at 2:56 pm
restore database "database name" with recovery
November 22, 2011 at 2:48 pm
As far as I know, you can't use the derived column name. You have to retype the full substring statement.
November 22, 2011 at 2:03 pm
Viewing 15 posts - 46 through 60 (of 62 total)