Viewing 15 posts - 286 through 300 (of 433 total)
You can use sql agent account provided the account should have permission
to read and write into the snapshot folder.
I have assigned the domain account to both sql server service and...
August 16, 2007 at 3:50 am
The above error clearly states that the log file is not matching . Please check the backup file with :
RESTORE FILELISTONLY command.
Please refer BOL om Simple recovery model.
Minaz
August 10, 2007 at 5:05 am
From the post you seem you have already followed the Kb and SP4 you will not be able to apply. Then try changing the collation and BCP out the data.
Minaz
August 10, 2007 at 4:55 am
This a a know issue with the collation "Latin1_General_BIN Collation ".
Please refer the following KB for FIX.http://support.microsoft.com/kb/822747/en-us
Minaz
August 10, 2007 at 4:52 am
What is the SQL Server version?
What is logged in the error log/ system and application event log ?
It will be helpfull if you try to post it here.
Minaz
August 9, 2007 at 5:42 am
1. Have you changed the MSSQLServer startup account &.or password?
2. Does the SQL Server login BUILTIN\Administrators exist? If so, does it
have master as the default database and sysadmin privileges if...
August 9, 2007 at 4:30 am
I hope the above post helped you this time.
you need to have a solid disaster recovery plan this is a primary job of a DBA.
There are so many articles in the...
August 9, 2007 at 3:54 am
I would like to know if you have set the autogrow settings for each file. (one for the primary data file and one for the primary log file).
If yes then what is...
August 9, 2007 at 3:24 am
Backup ..NO not possible.
Why not try to bcp/import the data to SQL 2000 fro SQL 2005.
Please review this link for more info:
http://www.aspfree.com/c/a/MS-SQL-Server/SQL-2000-Data-Transfer-is-a-Snap-with-SQL-2005/
Minaz
August 9, 2007 at 2:08 am
If you are setting up replication between the servers, you need to have domain account with admin privilleges on both the servers.
Start the MS SQLServer and SQL ServerAgent service with...
August 9, 2007 at 1:40 am
I think you need to prepare a migration doc and once changes are done migrate it to the target system (SQL Server database I think) by DTS import wizard.
Different options are available...
August 7, 2007 at 1:35 am
There are some tools available from Microsoft to monitor and diagnoses the issues:
1. Read80Trace is a command line utility for processing trace files generated by SQL Server 2000. As output,...
August 7, 2007 at 1:21 am
August 7, 2007 at 12:43 am
" that at some point in the day, for one particular customer "
-- check it out what time ( Any partucular time ) ?
-- What are the background job get...
August 6, 2007 at 11:43 pm
Viewing 15 posts - 286 through 300 (of 433 total)