Viewing 15 posts - 466 through 480 (of 575 total)
I havediscovered the problem. It is to do with 2 different service packs on the 2 SQL Servers.
May 13, 2004 at 9:18 pm
1 more thing!
This error occurs when SQL Server attempts to perfrom the snapshot.In other words the schema & data files getcreated successfully but fails whit that error when the snapshot...
May 13, 2004 at 5:22 pm
In my experience, it was less painfull to start from scratch rather than do an upgrade.
May 13, 2004 at 5:13 pm
racosta,
I configured and setup the Subscription via EM. This is a bit of a worry when EM has done this! Not sure what to do from here!
May 13, 2004 at 5:10 pm
The compatibility settings is for backward compatibility of some T-SQL/Stored Procedures. Some of this may have some impact on performance, but it all depends on which T-SQL Statement or System...
May 12, 2004 at 11:56 pm
Can't do it using Group Policy! You have to remember that SQL Server is a totally seperate Server and is NOT totally tied into the Windows Operating System.
When you create...
May 12, 2004 at 11:46 pm
Best way to do it is to create a T-SQL Script that kills all the users that still have a connection to that Database before executing the Maintenance plan.
May 12, 2004 at 11:39 pm
I don't think you can avoid torn pages however, you can turn on the Database Setting called "Torn Page Detection" which will notify you of any torn pages.
As for repairing...
May 10, 2004 at 11:53 pm
One way to do this is to get all the SQL Server Logins and create a T-SQL Script that uses the sp_password on each Login to change the password using...
May 10, 2004 at 11:50 pm
One possible explanation is that SQL Server had initiated the Snapshot again while the first Snapshot was already running!
Monitor this and see if it happens again!
May 10, 2004 at 11:42 pm
Try re-installing the SQL Server client tools again.
May 7, 2004 at 2:51 am
You can automate backups a couple of ways. 1 way is to right click the Database and select Backup Database and then schedule it from there.
What do you mean when...
May 7, 2004 at 2:49 am
Are you able to perform an adhoc backup as oppossed to a scheduled one?
If so, then there is obviously soemthing wrong with the SQL Server Agent Service.
May 4, 2004 at 5:13 am
In light of what happycat59 has said, Replication is not the best method of migrating a Database from 1 server to another!
How big is the Database? Surely you could fins...
May 4, 2004 at 5:05 am
Viewing 15 posts - 466 through 480 (of 575 total)