Viewing 15 posts - 1,231 through 1,245 (of 1,335 total)
does the account running the sql server have access to the share mentioned. If not then give access to that share and check if the proc runs fine.
February 12, 2007 at 4:58 am
Check for the size of the databases. if u can shrink them do that so that u can get some space on the disk. Also check for the backup files size...
February 12, 2007 at 4:55 am
Right click the server and use the following options to check and configure the connections properties in your sql server.
Right click the server, goto connections and set a value of...
February 12, 2007 at 4:52 am
Just read through the link below. it gives a brief description of setting up database mirroring.
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1199004,00.html
February 12, 2007 at 4:48 am
Did u check if there is any scheduled SQL restart of the server at that time. As this will cause the agent not to access the SQL server resulting in...
February 10, 2007 at 8:06 am
Set a growth in MBs ratherr than specifying in Percent. Modify th changes in MODEL database so that tempdb gets created with that properties every time sql server gets restarted.
February 10, 2007 at 8:03 am
Members of SecurityAdmin role can also do the same job. They can add users to the databases and control permissions.
February 10, 2007 at 7:59 am
Karthik,
Did u run the upgrade advisor before doing the upgrade. what was the output of the advisor. Did u resolve all those errors/warnings mentioned in the report generated.
February 9, 2007 at 11:37 pm
Follow this order while restoring the database.
1. Restore your full database backup
2. Restore your last differential backup
3. restore your transactional logs in a one by one in increasing time...
February 9, 2007 at 11:33 pm
U can use Merge replication so that the data in both the databases are in sync. Or if u just want the data in ur laptop to be reflected in...
February 9, 2007 at 11:30 pm
You can also use alerts and track ur error messsages and other processes in SQL Server. Mail if any alert occurs.
February 9, 2007 at 8:41 am
To the best of my knowledge SQL Server is non interactive. Which means that u can't invoke a new program from it. I have tried to invoke a exe from...
February 9, 2007 at 8:35 am
I too faced the same problem with DTC. In fact my first post in this forum was for the same problem and i have found the same solution as given...
February 7, 2007 at 10:04 pm
Is your call being blocked on the remote server / can you see your connection when monitoring the remote box
Yes this should be checked primarily is your source...
February 5, 2007 at 11:40 pm
also u can use the script from the below link to kill all users in the database.
http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=30
February 5, 2007 at 11:35 pm
Viewing 15 posts - 1,231 through 1,245 (of 1,335 total)