This happens when you are running a big transaction where the tempdb is being used. It will grow up automatically and will allow the transaction to complete. But If you dont have enough disk space it will fail. If you could make transactions simple that would help.
Hello all - Are there any disadvantages using a view in transactional replication. I am using Sql server 2000 enterprise edition and the objects being referenced by view already exists on the subscriber.
Are there any steps consider before adding a view to the publication.
Regards,
Cyno
Did you apply the initial snapshot?? When the snapshot agent runs it will drop and recreate the article at the subscriber by default.May be the subscriber table is source for different publication....
Cyno
Yes. You can implement bidirectional transactional replication. There should not be conflicts(updates more often). If you have updates(conflicts) more often then merge replication is best solution
http://support.microsoft.com/default.aspx?scid=820675
cyno
Looks like to me while one process is restoring the database it holds lock on the file and at the same time other process is trying to access the file. How big are the .TRN files???
Cyno
Did you see any records in log_shipping_plans table in msdb database???
Try to copy the plan name from the table and run
EXEC msdb.dbo.sp_delete_log_shipping_plan @plan_name = N'plan_name', @del_plan_db = 1
Cyno
Can you run this and see what happens
EXEC msdb.dbo.sp_delete_log_shipping_plan @plan_name = N['AUTHORIS-LTZB8F\PRODUCTION.pubs_logshipping'], @del_plan_db = 1
Cyno
Hi
We have Sql server 2000 Standard Edition with Service Pack 3a. I noticed a strange thing on the server. When i try to modify the permissions for a standard login the server will prompt to confirm the password. It is not happening for the Windows account. And even when i give the password...
I tried the below restore command and it worked for me. May be issues with the server access... Just guessing..
RESTORE DATABASE dbname
FROM disk='\\server\D$\path\filename.bak'
WITH STANDBY='D:\path\name.sby',
MOVE 'logical_datafile_name' TO 'D:\sqldata\file.mdf',
MOVE...
Run the following command in the QA
sp_help_fulltext_catalogs
It will return the catalog name. After that you can run this command specifying the catalog name as parameter to get table name
sp_help_fulltext_tables 'catalog name'
Cyno
Hi
We have a table in which we need to audit the deletes. And iam creating a trigger for delete.I know we can use the user_name to get the DB user. Is there a way to get the workstation(hostname)name and login information as we have standard logins on that server and its hard to find which...
Hi All
I would like to remove unnecessary users and logins from one of the servers. But i am afraid if any of the application or process may be still using that login. Is there any way that we can confirm that the application is not using the login anymore
Cyno
NORECOVERY
Used only with BACKUP LOG. Backs up the tail of the log and leaves the database in the Restoring state. NORECOVERY is useful when failing over to a secondary database or when saving the tail of the log prior to a RESTORE operation.
STANDBY = undo_file_name
Used only with BACKUP...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.