Viewing 15 posts - 136 through 150 (of 629 total)
If the backup files are stored on the source server; you'll need to open port 135 I believe so you can access the UNC path on the source server.
I believe...
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 11, 2009 at 4:12 pm
Look up CAST and COVERT functions in books online :).
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 11, 2009 at 4:09 pm
Do you have backup for you master database?
I would rebuild the database and restore it from backup to get in operations. Copying master database from another instance is not best...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 11, 2009 at 3:19 pm
I prefer mirroring because of automatic failover ...
Microsoft article on setting up Mirroring with sharepoint:
http://technet.microsoft.com/en-us/library/cc262910.aspx
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 11, 2009 at 1:11 pm
There is no tool to repair Access DB file but what is the issue you are running into?
The normal repair that I have used and been successful with is create...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 11, 2009 at 11:17 am
Few things come to mind ...
1) Express edition does not allow remote connections by default; you must enable it.
2) If you already have an instance running on serer your second...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 11, 2009 at 10:54 am
You can do that but I wouldn't recommend it; because in a 3-partner (Principal-Mirror-Witness) configuration; if two partners go down then the remaining partner database become inaccessible.
So in this case...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 9, 2009 at 2:29 pm
Hi Simon,
How is your network configured? Where is the web server and where is the SQL Server? Are they on the same subnet? Ideal recommendation ...
- Have...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 9, 2009 at 8:09 am
Heh Thanks Lynn. I have never rolled backed as I said I have uninstall / reinstall. Making sure to have my System DB backups so I was able...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 8, 2009 at 11:26 am
It can affect the system dbs because resource db is updated when patches are applied; because if resource db fells out of sync from the sql version we can have...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 8, 2009 at 10:40 am
How I normally do it is, I verify no security issues exist that will affect my environment. From there I only patch SQL server twice per year, unless of...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 7, 2009 at 10:29 pm
1. To get the email address from a table just do a DECLARE and SELECT statement to pull the information like you did to see if the email needs to...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 5, 2009 at 4:40 pm
Few things to check if automatic failover is not taking place:
1) Both servers can see witness.
2) Your mirroring is set to automatic failover.
SELECT *
FROM sys.database_mirroring
Columns of interest: mirroring_witness_state_desc,...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 3, 2009 at 11:20 am
lwolfe (4/1/2009)
69
select count(*) from [Database_Name].sys.database_principals
33
select *
from master.sys.server_principals
where sid in (select sid from [Database_Name].sys.database_principals)
15
select *
from master.sys.server_principals
where sid in (select sid from [Database_Name].sys.database_principals)
0...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 1, 2009 at 11:55 am
Cheers :). Sorry didn't get back to you, have fun with Mirroring. I absolutely love Mirroring :blush:.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 1, 2009 at 9:10 am
Viewing 15 posts - 136 through 150 (of 629 total)